#coding:utf-8

import json
from taobao.mysqls import PyMysql
import requests
cursor=PyMysql().pymysql_conn()
import pandas as pd
data=requests.get('http://127.0.0.1:5000/main/cyt?tabName=yyjj').text

print(data)
from collections import Counter
#
# sql = "SELECT title FROM yi_yong_jiu_jing;"  # sql语句
#
# cursor.execute(sql)  # execute(query, args):执行单条sql语句。
# see = cursor.fetchall()  # 使结果全部可看
# app=[]
# info={}
# for i in see:
#     title=i[0]
#     for n in title:
#         app.append(n)
#
# import collections
#
# c=collections.Counter(app)
# result=[]
# for key,value in c.items():
#     result.append({
#         'name':key,
#         'value':value
#     })
# print(result)



















    #df=pd.DataFrame(title)




# app={}
# for i in x:
#     if i=='上海' or i=='北京' or i=='广东' or i=='安徽' or i=='湖南':
#         value=True
#     else:
#         value=False
#     app[i]=value
# print(app)
#
# a={'上海': True, '云南': False, '加拿大': False, '北京': True, '吉林': False, '四川': False, '天津': False, '安徽': True, '山东': False, '山西': False, '广东': True, '广西': False, '新疆': False, '江苏': False, '江西': False, '河北': False, '河南': False, '浙江': False, '海南': False, '湖北': False, '湖南': True, '福建': False, '美国': False, '贵州': False, '辽宁': False, '重庆': False, '陕西': False, '黑龙江': False}
#

# import pinyin
#
#
#
# a=pinyin.get("医用酒精",delimiter='_',format='strip')
# print(a)
